inherited frmTotalClienteRel: TfrmTotalClienteRel
  Caption = 'Total por Cliente'
  ClientHeight = 242
  PixelsPerInch = 96
  TextHeight = 13
  inherited pnlOpcoes: TPanel
    Height = 157
    inherited Label6: TLabel
      Left = 16
      Top = 152
      Visible = False
    end
    object Label7: TLabel [8]
      Left = 192
      Top = 113
      Width = 35
      Height = 13
      Caption = 'Pessoa'
    end
    inherited EdtUsuarioCod: TEdit
      Left = 16
      Top = 168
      Visible = False
    end
    inherited BtnUsuario: TBitBtn
      Left = 66
      Top = 168
      Visible = False
    end
    inherited EdtUsuarioNome: TStaticText
      Left = 88
      Top = 168
      Visible = False
    end
    object EditCodPessoa: TEdit
      Left = 192
      Top = 126
      Width = 56
      Height = 21
      TabOrder = 14
      OnExit = EditCodPessoaExit
    end
    object btnPessoa: TBitBtn
      Left = 247
      Top = 126
      Width = 25
      Height = 22
      Caption = '...'
      TabOrder = 15
      TabStop = False
      OnClick = btnPessoaClick
    end
    object stNome: TStaticText
      Left = 272
      Top = 128
      Width = 161
      Height = 19
      AutoSize = False
      BorderStyle = sbsSingle
      TabOrder = 16
    end
  end
  inherited pnlBotoes: TPanel
    Top = 198
    inherited BitBtn1: TBitBtn
      Enabled = False
    end
  end
  inherited pnlCabecalho: TPanel
    Caption = 'Total por Cliente'
  end
  inherited sql_dataset_principal: TSQLClientDataSet
    CommandText = 
      'select SD.SAD_CODCLI, PE.PES_NOME, PE.PES_EMAIL, PE.PES_FONE,'#13#10'S' +
      'UM(SI.SAI_QUANTI*SI.SAI_PREVEN) as Total, SUM(SI.SAI_QUANTI) as ' +
      'Itens '#13#10'from SAIDA_DOCUMENTO SD '#13#10'inner join SAIDA_ITEM SI ON SI' +
      '.SAI_IDFDOC=SD.SAD_IDFDOC '#13#10'inner join PESSOAS PE ON PE.PES_IDFC' +
      'OD=SD.SAD_CODCLI '#13#10'GROUP BY SAD_CODVEN, SD.SAD_CODCLI, PE.PES_NO' +
      'ME, PE.PES_EMAIL, PE.PES_FONE '#13#10'order by SD.SAD_CODCLI;'
    object sql_dataset_principalSAD_CODCLI: TIntegerField
      FieldName = 'SAD_CODCLI'
      Required = True
    end
    object sql_dataset_principalPES_NOME: TStringField
      FieldName = 'PES_NOME'
      Required = True
      Size = 60
    end
    object sql_dataset_principalPES_FONE: TStringField
      FieldName = 'PES_FONE'
      Size = 30
    end
    object sql_dataset_principalTOTAL: TFMTBCDField
      FieldName = 'TOTAL'
      Precision = 15
      Size = 7
    end
    object sql_dataset_principalITENS: TFMTBCDField
      FieldName = 'ITENS'
      Precision = 15
      Size = 3
    end
    object sql_dataset_principalPES_EMAIL: TStringField
      FieldName = 'PES_EMAIL'
      Size = 60
    end
  end
  inherited rds_dataset_principal: TRvDataSetConnection
    Left = 336
    Top = 137
  end
end
